A linked server configuration enables SQL Server to execute commands against OLE DB data sources on remote servers. Linked servers offer the following advantages:
- Remote server access.
- The ability to issue distributed queries, updates, commands, and transactions on heterogeneous data sources across the enterprise.
- The ability to address diverse data sources similarly.
Note: SQL Azure does not support.
Just simply click ->
Linked Server to open
an object pane for Linked Server. A control-click displays the
popup menu or using the object pane toolbar below, allowing you to create
new, edit and delete the selected linked server.
Create Linked Server
To create a new linked server
- Select anywhere on the object pane.
- Click the
from the object pane toolbar.
or - Control-click and select New Linked Server from the popup menu.
- Edit linked server properties on the appropriate tabs of the Linked Server Designer.
To create a new linked server with modification as one of the existing linked server
- Select the linked server for modifying in the object pane.
- Control-click and select the Design
Linked Server from the popup menu or simply double-click the linked server.
or - Click the
from the object pane toolbar.
- Modify linked server properties on the appropriate tabs of the Linked Server Designer.
- Click
Save As.
To edit the existing linked server(manage its general etc)
- Select the linked server for editing in the object pane.
- Control-click and select the Design
Linked Server from the popup menu or simply double-click the linked server.
or - Click the
from the object pane toolbar.
- Edit linked server properties on the appropriate tabs of the Linked Server Designer.
To test the existing linked server
- Select the linked server for editing in the object pane.
- Control-click and select the Test Linked Server from the popup menu.
Delete Linked Server
To delete a linked server
- Select the linked server for deleting in the object pane.
- Control-click and select the Delete Linked Server
from the popup menu.
or - Click the
from the object pane toolbar.
- Confirm deleting in the dialog window.
Achieve Linked Server Information
To achieve a linked server information
- Select the linked server in the object pane.
- Choose View -> Object Information in the main menu to view the Object Information.
or - Click the
from the object pane toolbar.